package com.health.tablebean.webservice;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.health.viewscontrols.NovaApplication;
import com.health.db.FDbManager;
import com.health.tablebean.ARCHIVE_ASSESSMENTGUIDE;
import com.health.tablebean.ARCHIVE_ASSISTCHECK;
import com.health.tablebean.ARCHIVE_CUSTOMERBASEINFO;
import com.health.tablebean.ARCHIVE_FAMILYBEDHISTORY;
import com.health.tablebean.ARCHIVE_GENERALCONDITION;
import com.health.tablebean.ARCHIVE_HEALTHQUESTION;
import com.health.tablebean.ARCHIVE_HOSPITALHISTORY;
import com.health.tablebean.ARCHIVE_INOCULATIONHISTORY;
import com.health.tablebean.ARCHIVE_LIFESTYLE;
import com.health.tablebean.ARCHIVE_MEDICATION;
import com.health.tablebean.ARCHIVE_PHYSICALEXAM;
import com.health.tablebean.ARCHIVE_VISCERAFUNCTION;
import com.health.tablebean.OLD_MEDICINE_CN;
import com.health.tablebean.OLD_MEDICINE_RESULT;
import com.health.tools.GlobalConts;

import android.content.Context;
import android.text.TextUtils;

/**
 * @author Administrator 健康体检 数据转换
 */
public class HealthCheck {

	private HdPersonalHealth hdPersonalHealth;
	private HdPersonalHealthAssist hdPersonalHealthAssist;

	public HdPersonalHealth getHdPersonalHealth() {
		return hdPersonalHealth;
	}

	public void setHdPersonalHealth(HdPersonalHealth hdPersonalHealth) {
		this.hdPersonalHealth = hdPersonalHealth;
	}

	public HdPersonalHealthAssist getHdPersonalHealthAssist() {
		return hdPersonalHealthAssist;
	}

	public void setHdPersonalHealthAssist(HdPersonalHealthAssist hdPersonalHealthAssist) {
		this.hdPersonalHealthAssist = hdPersonalHealthAssist;
	}

	private static class HdPersonalHealth {
		private String cardid;// VARCHAR2(18) 居民身份证/健康卡号
		private String chemie;// VARCHAR2(100) 化学物质
		private String col0001;// VARCHAR2(500) 主要症状代码组合
		private String col0002;// VARCHAR2(240) 其他症状描述
		private String col0003;// VARCHAR2(100) 患病情况描述
		private String col0004;// VARCHAR2(20) 老年健康自评代码
		private String col0005;// VARCHAR2(20) 老年自理能力评估
		private String col0006;// VARCHAR2(20) 老年认知初筛结果
		private String col0007;// NUMBER(3) 老年认知功能评分
		private String col0008;// VARCHAR2(20) 老年情感初筛结果
		private String col0009;// NUMBER(3) 老年人抑郁评分
		private String col0010;// NUMBER(3) 身高(cm)
		private String col0011;// NUMBER 体重（kg）
		private String col0012;// NUMBER(3) 臀围(cm)
		private String col0013;// NUMBER 腰围(cm)
		private String col0014;// NUMBER 体温(℃)
		private String col0015;// NUMBER(3) 脉率
		private String col0016;// NUMBER(3) 呼吸频率（次/分钟）
		private String col0017;// NUMBER 收缩压(mmHg)
		private String col0018;// NUMBER 舒张压(mmHg)
		private String col0019;// NUMBER 左侧收缩压（mmHg)
		private String col0020;// NUMBER 左侧舒张压（m m Hg)
		private String col0021;// NUMBER 右侧收缩压（mmHg)
		private String col0022;// NUMBER 右侧舒张压（mmHg)
		private String col0023;// NUMBER 体质指数
		private String col0024;// VARCHAR2(120) 齿列类别代码
		private String col0026;// VARCHAR2(20) 咽部检査结果代码
		private String col0027;// NUMBER 左眼裸眼远视力值
		private String col0028;// NUMBER 右眼裸眼远视力值
		private String col0029;// NUMBER 左眼矫正远视力值
		private String col0030;// NUMBER 右眼矫正远视力值
		private String col0031;// VARCHAR2(20) 眼底检查结果代码
		private String col0034;// VARCHAR2(20) 巩膜检查结果
		private String col0035;// VARCHAR2(100) 眼检查异常描述
		private String col0036;// VARCHAR2(20) 听力检测结果代码
		private String col0046;// VARCHAR2(20) 口唇外观检查结果代码
		private String col0047;// NUMBER(2) 龋齿数（颗）
		private String col0048;// NUMBER(2) 缺齿数（颗）
		private String col0049;// NUMBER(2) 义齿数（颗）
		private String col0052;// VARCHAR2(20) 皮肤检查结果代码
		private String col0053;// VARCHAR2(200) 乳腺检查结果代码
		private String col0054;// VARCHAR2(20) 足背动脉搏动代码
		private String col0055;// VARCHAR2(20) 运动功能状态代码
		private String col0059;// VARCHAR2(200) 淋巴结检查结果代码
		private String col0060;// VARCHAR2(20) 下肢水肿检查结果代码
		private String col0061;// VARCHAR2(20) 肛门指诊检查结果代码
		private String col0066;// VARCHAR2(20) 肺部罗音代码
		private String col0067;// VARCHAR2(20) 肺部异常呼吸音标志
		private String col0068;// VARCHAR2(20) 腹部移动性浊音标志
		private String col0069;// VARCHAR2(20) 腹部压痛标志
		private String col0070;// VARCHAR2(20) 腹部包块标志
		private String col0072;// VARCHAR2(20) 肝大标志
		private String col0073;// VARCHAR2(20) 脾大标志
		private String col0075;// NUMBER 心率(次/min)
		private String col0076;// VARCHAR2(100) 心律类别代码
		private String col0077;// VARCHAR2(100) 心脏杂音标志
		private String col0082;// VARCHAR2(20) 外阴异常标志
		private String col0083;// VARCHAR2(100) 阴道检查结果代码
		private String col0084;// VARCHAR2(100) 宫颈检查结果代码
		private String col0085;// VARCHAR2(100) 宫体检查结果代码
		private String col0086;// VARCHAR2(100) 附件异常标志
		private String col0140;// VARCHAR2(20) 健康评价结果代码
		private String col0142;// VARCHAR2(80) 健康指导代码
		private String col0146;// VARCHAR2(20) 桶状胸标志
		private String col0147;// VARCHAR2(100) 肺部异常呼吸音描述
		private String col0148;// VARCHAR2(100) 肺部罗音描述
		private String col0149;// VARCHAR2(100) 腹部压痛描述
		private String col0150;// VARCHAR2(100) 腹部包块描述
		private String col0151;// VARCHAR2(100) 肝大描述
		private String col0152;// VARCHAR2(100) 脾大描述
		private String col0153;// VARCHAR2(100) 腹部移动性浊音描述
		private String col0154;// VARCHAR2(100) 肛门指诊其它
		private String col0156;// VARCHAR2(100) 外阴异常描述
		private String col0157;// VARCHAR2(100) 阴道异常描述
		private String col0158;// VARCHAR2(100) 宫颈异常描述
		private String col0159;// VARCHAR2(100) 宫体异常描述
		private String col0160;// VARCHAR2(100) 附件异常描述
		private String col0161;// VARCHAR2(100) 其他查体结果
		private String col0174;// VARCHAR2(100) 脑血管疾病
		private String col0175;// VARCHAR2(100) 脑血管疾病其它
		private String col0176;// VARCHAR2(100) 肾脏疾病
		private String col0177;// VARCHAR2(100) 肾脏疾病其他
		private String col0178;// VARCHAR2(100) 心脏疾病
		private String col0179;// VARCHAR2(100) 心脏疾病其他
		private String col0180;// VARCHAR2(100) 血管疾病
		private String col0181;// VARCHAR2(100) 血管疾病其他
		private String col0182;// VARCHAR2(100) 眼部疾病
		private String col0183;// VARCHAR2(100) 眼部疾病其他
		private String col0184;// VARCHAR2(100) 神经系统疾病
		private String col0185;// VARCHAR2(40) 有神经系统疾病
		private String col0186;// VARCHAR2(20) 其他系统疾病
		private String col0187;// VARCHAR2(40) 有其他系统疾病
		private String col0188;// VARCHAR2(150) 健康评价异常1描述
		private String col0189;// VARCHAR2(50) 目标体重（kg)
		private String col0190;// VARCHAR2(200) 建议接种疫苗名称代码
		private String col0191;// VARCHAR2(250) 危险因素控制其他
		private String col0195;// VARCHAR2(100) 巩膜其他描述
		private String col0196;// VARCHAR2(100) 淋巴结其他描述
		private String col0197;// VARCHAR2(100) 心脏杂音其他描述
		private String createorg;
		private String creater;
		private String createtime;
		private String dust;// 粉尘
		private String emit;// 放射物质
		private String fromType;// 数据来源；空为公卫，‘1’为手提箱，‘2’为PAD
		private String happentime;// 建档时间
		private HdPersonalAbstract hdPersonalAbstract;
		private List<HdPersonalHospitalList> hdPersonalHospitalList;
		private List<HdPersonalPharmacyList> hdPersonalPharmacyList;
		private List<HdPersonalSickbedList> hdPersonalSickbedList;
		private String other;// 职业病危害因素接触史其他有无标识
		private String phy;// 物理因素有无
		private String qdqxz;// 缺项值
		private String quChiLeftDown;// 缺齿 左下
		private String quChiLeftUp;// 缺齿 左上
		private String quChiRightDown;// 缺齿 右下
		private String quChiRightUp;// 龋齿 右上
		private String queChiLeftDown;// 缺齿 右上
		private String queChiLeftUp;// 缺齿 左上
		private String queChiRightDown;// 缺齿 右下
		private String queChiRightUp;// 缺齿 右上
		private String res0;// 皮肤
		private String res1;// 乳腺
		private String res2;// 危险因素控制
		private String res3;// 健康评价异常2描述
		private String res4;// 健康评价异常3描述
		private String res5;// 健康评价异常4描述
		private String surgeonName;// 责任医师姓名
		private String wzd;// 完整度(weitianjia)
		private List<Yfjz> yfjz;
		private String yiChiLeftDown; // 义齿 左下
		private String yiChiLeftUp; // 义齿 左上
		private String yiChiRightDown; // 义齿 右下
		private String yiChiRightUp; // 义齿右上
		private String ywjcs;// 有无家庭病床史(no)
		private String ywjys;// 有无住院史(no)
		private String ywyfjz;// 有无预防接种史(no)
		private String ywyyqk;// 有无用药情况(no)

		public String getCreateorg() {
			return createorg;
		}

		public void setCreateorg(String createorg) {
			this.createorg = createorg;
		}

		public String getCreater() {
			return creater;
		}

		public void setCreater(String creater) {
			this.creater = creater;
		}

		public String getCreatetime() {
			return createtime;
		}

		public void setCreatetime(String createtime) {
			this.createtime = createtime;
		}

		public String getCardid() {
			return cardid;
		}

		public void setCardid(String cardid) {
			this.cardid = cardid;
		}

		public String getChemie() {
			return chemie;
		}

		public void setChemie(String chemie) {
			this.chemie = chemie;
		}

		public String getCol0001() {
			return col0001;
		}

		public void setCol0001(String col0001) {
			this.col0001 = col0001;
		}

		public String getCol0002() {
			return col0002;
		}

		public void setCol0002(String col0002) {
			this.col0002 = col0002;
		}

		public String getCol0003() {
			return col0003;
		}

		public void setCol0003(String col0003) {
			this.col0003 = col0003;
		}

		public String getCol0004() {
			return col0004;
		}

		public void setCol0004(String col0004) {
			this.col0004 = col0004;
		}

		public String getCol0005() {
			return col0005;
		}

		public void setCol0005(String col0005) {
			this.col0005 = col0005;
		}

		public String getCol0006() {
			return col0006;
		}

		public void setCol0006(String col0006) {
			this.col0006 = col0006;
		}

		public String getCol0007() {
			return col0007;
		}

		public void setCol0007(String col0007) {
			this.col0007 = col0007;
		}

		public String getCol0008() {
			return col0008;
		}

		public void setCol0008(String col0008) {
			this.col0008 = col0008;
		}

		public String getCol0009() {
			return col0009;
		}

		public void setCol0009(String col0009) {
			this.col0009 = col0009;
		}

		public String getCol0010() {
			return col0010;
		}

		public void setCol0010(String col0010) {
			this.col0010 = col0010;
		}

		public String getCol0011() {
			return col0011;
		}

		public void setCol0011(String col0011) {
			this.col0011 = col0011;
		}

		public String getCol0012() {
			return col0012;
		}

		public void setCol0012(String col0012) {
			this.col0012 = col0012;
		}

		public String getCol0013() {
			return col0013;
		}

		public void setCol0013(String col0013) {
			this.col0013 = col0013;
		}

		public String getCol0014() {
			return col0014;
		}

		public void setCol0014(String col0014) {
			this.col0014 = col0014;
		}

		public String getCol0015() {
			return col0015;
		}

		public void setCol0015(String col0015) {
			this.col0015 = col0015;
		}

		public String getCol0016() {
			return col0016;
		}

		public void setCol0016(String col0016) {
			this.col0016 = col0016;
		}

		public String getCol0017() {
			return col0017;
		}

		public void setCol0017(String col0017) {
			this.col0017 = col0017;
		}

		public String getCol0018() {
			return col0018;
		}

		public void setCol0018(String col0018) {
			this.col0018 = col0018;
		}

		public String getCol0019() {
			return col0019;
		}

		public void setCol0019(String col0019) {
			this.col0019 = col0019;
		}

		public String getCol0020() {
			return col0020;
		}

		public void setCol0020(String col0020) {
			this.col0020 = col0020;
		}

		public String getCol0021() {
			return col0021;
		}

		public void setCol0021(String col0021) {
			this.col0021 = col0021;
		}

		public String getCol0022() {
			return col0022;
		}

		public void setCol0022(String col0022) {
			this.col0022 = col0022;
		}

		public String getCol0023() {
			return col0023;
		}

		public void setCol0023(String col0023) {
			this.col0023 = col0023;
		}

		public String getCol0024() {
			return col0024;
		}

		public void setCol0024(String col0024) {
			this.col0024 = col0024;
		}

		public String getCol0026() {
			return col0026;
		}

		public void setCol0026(String col0026) {
			this.col0026 = col0026;
		}

		public String getCol0027() {
			return col0027;
		}

		public void setCol0027(String col0027) {
			this.col0027 = col0027;
		}

		public String getCol0028() {
			return col0028;
		}

		public void setCol0028(String col0028) {
			this.col0028 = col0028;
		}

		public String getCol0029() {
			return col0029;
		}

		public void setCol0029(String col0029) {
			this.col0029 = col0029;
		}

		public String getCol0030() {
			return col0030;
		}

		public void setCol0030(String col0030) {
			this.col0030 = col0030;
		}

		public String getCol0031() {
			return col0031;
		}

		public void setCol0031(String col0031) {
			this.col0031 = col0031;
		}

		public String getCol0034() {
			return col0034;
		}

		public void setCol0034(String col0034) {
			this.col0034 = col0034;
		}

		public String getCol0035() {
			return col0035;
		}

		public void setCol0035(String col0035) {
			this.col0035 = col0035;
		}

		public String getCol0036() {
			return col0036;
		}

		public void setCol0036(String col0036) {
			this.col0036 = col0036;
		}

		public String getCol0046() {
			return col0046;
		}

		public void setCol0046(String col0046) {
			this.col0046 = col0046;
		}

		public String getCol0047() {
			return col0047;
		}

		public void setCol0047(String col0047) {
			this.col0047 = col0047;
		}

		public String getCol0048() {
			return col0048;
		}

		public void setCol0048(String col0048) {
			this.col0048 = col0048;
		}

		public String getCol0049() {
			return col0049;
		}

		public void setCol0049(String col0049) {
			this.col0049 = col0049;
		}

		public String getCol0052() {
			return col0052;
		}

		public void setCol0052(String col0052) {
			this.col0052 = col0052;
		}

		public String getCol0053() {
			return col0053;
		}

		public void setCol0053(String col0053) {
			this.col0053 = col0053;
		}

		public String getCol0054() {
			return col0054;
		}

		public void setCol0054(String col0054) {
			this.col0054 = col0054;
		}

		public String getCol0055() {
			return col0055;
		}

		public void setCol0055(String col0055) {
			this.col0055 = col0055;
		}

		public String getCol0059() {
			return col0059;
		}

		public void setCol0059(String col0059) {
			this.col0059 = col0059;
		}

		public String getCol0060() {
			return col0060;
		}

		public void setCol0060(String col0060) {
			this.col0060 = col0060;
		}

		public String getCol0061() {
			return col0061;
		}

		public void setCol0061(String col0061) {
			this.col0061 = col0061;
		}

		public String getCol0066() {
			return col0066;
		}

		public void setCol0066(String col0066) {
			this.col0066 = col0066;
		}

		public String getCol0067() {
			return col0067;
		}

		public void setCol0067(String col0067) {
			this.col0067 = col0067;
		}

		public String getCol0068() {
			return col0068;
		}

		public void setCol0068(String col0068) {
			this.col0068 = col0068;
		}

		public String getCol0069() {
			return col0069;
		}

		public void setCol0069(String col0069) {
			this.col0069 = col0069;
		}

		public String getCol0070() {
			return col0070;
		}

		public void setCol0070(String col0070) {
			this.col0070 = col0070;
		}

		public String getCol0072() {
			return col0072;
		}

		public void setCol0072(String col0072) {
			this.col0072 = col0072;
		}

		public String getCol0073() {
			return col0073;
		}

		public void setCol0073(String col0073) {
			this.col0073 = col0073;
		}

		public String getCol0075() {
			return col0075;
		}

		public void setCol0075(String col0075) {
			this.col0075 = col0075;
		}

		public String getCol0076() {
			return col0076;
		}

		public void setCol0076(String col0076) {
			this.col0076 = col0076;
		}

		public String getCol0077() {
			return col0077;
		}

		public void setCol0077(String col0077) {
			this.col0077 = col0077;
		}

		public String getCol0082() {
			return col0082;
		}

		public void setCol0082(String col0082) {
			this.col0082 = col0082;
		}

		public String getCol0083() {
			return col0083;
		}

		public void setCol0083(String col0083) {
			this.col0083 = col0083;
		}

		public String getCol0084() {
			return col0084;
		}

		public void setCol0084(String col0084) {
			this.col0084 = col0084;
		}

		public String getCol0085() {
			return col0085;
		}

		public void setCol0085(String col0085) {
			this.col0085 = col0085;
		}

		public String getCol0086() {
			return col0086;
		}

		public void setCol0086(String col0086) {
			this.col0086 = col0086;
		}

		public String getCol0140() {
			return col0140;
		}

		public void setCol0140(String col0140) {
			this.col0140 = col0140;
		}

		public String getCol0142() {
			return col0142;
		}

		public void setCol0142(String col0142) {
			this.col0142 = col0142;
		}

		public String getCol0146() {
			return col0146;
		}

		public void setCol0146(String col0146) {
			this.col0146 = col0146;
		}

		public String getCol0147() {
			return col0147;
		}

		public void setCol0147(String col0147) {
			this.col0147 = col0147;
		}

		public String getCol0148() {
			return col0148;
		}

		public void setCol0148(String col0148) {
			this.col0148 = col0148;
		}

		public String getCol0149() {
			return col0149;
		}

		public void setCol0149(String col0149) {
			this.col0149 = col0149;
		}

		public String getCol0150() {
			return col0150;
		}

		public void setCol0150(String col0150) {
			this.col0150 = col0150;
		}

		public String getCol0151() {
			return col0151;
		}

		public void setCol0151(String col0151) {
			this.col0151 = col0151;
		}

		public String getCol0152() {
			return col0152;
		}

		public void setCol0152(String col0152) {
			this.col0152 = col0152;
		}

		public String getCol0153() {
			return col0153;
		}

		public void setCol0153(String col0153) {
			this.col0153 = col0153;
		}

		public String getCol0154() {
			return col0154;
		}

		public void setCol0154(String col0154) {
			this.col0154 = col0154;
		}

		public String getCol0156() {
			return col0156;
		}

		public void setCol0156(String col0156) {
			this.col0156 = col0156;
		}

		public String getCol0157() {
			return col0157;
		}

		public void setCol0157(String col0157) {
			this.col0157 = col0157;
		}

		public String getCol0158() {
			return col0158;
		}

		public void setCol0158(String col0158) {
			this.col0158 = col0158;
		}

		public String getCol0159() {
			return col0159;
		}

		public void setCol0159(String col0159) {
			this.col0159 = col0159;
		}

		public String getCol0160() {
			return col0160;
		}

		public void setCol0160(String col0160) {
			this.col0160 = col0160;
		}

		public String getCol0161() {
			return col0161;
		}

		public void setCol0161(String col0161) {
			this.col0161 = col0161;
		}

		public String getCol0174() {
			return col0174;
		}

		public void setCol0174(String col0174) {
			this.col0174 = col0174;
		}

		public String getCol0175() {
			return col0175;
		}

		public void setCol0175(String col0175) {
			this.col0175 = col0175;
		}

		public String getCol0176() {
			return col0176;
		}

		public void setCol0176(String col0176) {
			this.col0176 = col0176;
		}

		public String getCol0177() {
			return col0177;
		}

		public void setCol0177(String col0177) {
			this.col0177 = col0177;
		}

		public String getCol0178() {
			return col0178;
		}

		public void setCol0178(String col0178) {
			this.col0178 = col0178;
		}

		public String getCol0179() {
			return col0179;
		}

		public void setCol0179(String col0179) {
			this.col0179 = col0179;
		}

		public String getCol0180() {
			return col0180;
		}

		public void setCol0180(String col0180) {
			this.col0180 = col0180;
		}

		public String getCol0181() {
			return col0181;
		}

		public void setCol0181(String col0181) {
			this.col0181 = col0181;
		}

		public String getCol0182() {
			return col0182;
		}

		public void setCol0182(String col0182) {
			this.col0182 = col0182;
		}

		public String getCol0183() {
			return col0183;
		}

		public void setCol0183(String col0183) {
			this.col0183 = col0183;
		}

		public String getCol0184() {
			return col0184;
		}

		public void setCol0184(String col0184) {
			this.col0184 = col0184;
		}

		public String getCol0185() {
			return col0185;
		}

		public void setCol0185(String col0185) {
			this.col0185 = col0185;
		}

		public String getCol0186() {
			return col0186;
		}

		public void setCol0186(String col0186) {
			this.col0186 = col0186;
		}

		public String getCol0187() {
			return col0187;
		}

		public void setCol0187(String col0187) {
			this.col0187 = col0187;
		}

		public String getCol0188() {
			return col0188;
		}

		public void setCol0188(String col0188) {
			this.col0188 = col0188;
		}

		public String getCol0189() {
			return col0189;
		}

		public void setCol0189(String col0189) {
			this.col0189 = col0189;
		}

		public String getCol0190() {
			return col0190;
		}

		public void setCol0190(String col0190) {
			this.col0190 = col0190;
		}

		public String getCol0191() {
			return col0191;
		}

		public void setCol0191(String col0191) {
			this.col0191 = col0191;
		}

		public String getCol0195() {
			return col0195;
		}

		public void setCol0195(String col0195) {
			this.col0195 = col0195;
		}

		public String getCol0196() {
			return col0196;
		}

		public void setCol0196(String col0196) {
			this.col0196 = col0196;
		}

		public String getCol0197() {
			return col0197;
		}

		public void setCol0197(String col0197) {
			this.col0197 = col0197;
		}

		public HdPersonalAbstract getHdPersonalAbstract() {
			return hdPersonalAbstract;
		}

		public void setHdPersonalAbstract(HdPersonalAbstract hdPersonalAbstract) {
			this.hdPersonalAbstract = hdPersonalAbstract;
		}

		public String getDust() {
			return dust;
		}

		public void setDust(String dust) {
			this.dust = dust;
		}

		public String getEmit() {
			return emit;
		}

		public void setEmit(String emit) {
			this.emit = emit;
		}

		public String getFromType() {
			return fromType;
		}

		public void setFromType(String fromType) {
			this.fromType = fromType;
		}

		public String getHappentime() {
			return happentime;
		}

		public void setHappentime(String happentime) {
			this.happentime = happentime;
		}

		public List<HdPersonalHospitalList> getHdPersonalHospitalList() {
			return hdPersonalHospitalList;
		}

		public void setHdPersonalHospitalList(List<HdPersonalHospitalList> hdPersonalHospitalList) {
			this.hdPersonalHospitalList = hdPersonalHospitalList;
		}

		public List<HdPersonalPharmacyList> getHdPersonalPharmacyList() {
			return hdPersonalPharmacyList;
		}

		public void setHdPersonalPharmacyList(List<HdPersonalPharmacyList> hdPersonalPharmacyList) {
			this.hdPersonalPharmacyList = hdPersonalPharmacyList;
		}

		public List<HdPersonalSickbedList> getHdPersonalSickbedList() {
			return hdPersonalSickbedList;
		}

		public void setHdPersonalSickbedList(List<HdPersonalSickbedList> hdPersonalSickbedList) {
			this.hdPersonalSickbedList = hdPersonalSickbedList;
		}

		public String getOther() {
			return other;
		}

		public void setOther(String other) {
			this.other = other;
		}

		public String getPhy() {
			return phy;
		}

		public void setPhy(String phy) {
			this.phy = phy;
		}

		public String getQdqxz() {
			return qdqxz;
		}

		public void setQdqxz(String qdqxz) {
			this.qdqxz = qdqxz;
		}

		public String getQuChiLeftDown() {
			return quChiLeftDown;
		}

		public void setQuChiLeftDown(String quChiLeftDown) {
			this.quChiLeftDown = quChiLeftDown;
		}

		public String getQuChiLeftUp() {
			return quChiLeftUp;
		}

		public void setQuChiLeftUp(String quChiLeftUp) {
			this.quChiLeftUp = quChiLeftUp;
		}

		public String getQuChiRightDown() {
			return quChiRightDown;
		}

		public void setQuChiRightDown(String quChiRightDown) {
			this.quChiRightDown = quChiRightDown;
		}

		public String getQuChiRightUp() {
			return quChiRightUp;
		}

		public void setQuChiRightUp(String quChiRightUp) {
			this.quChiRightUp = quChiRightUp;
		}

		public String getQueChiLeftDown() {
			return queChiLeftDown;
		}

		public void setQueChiLeftDown(String queChiLeftDown) {
			this.queChiLeftDown = queChiLeftDown;
		}

		public String getQueChiLeftUp() {
			return queChiLeftUp;
		}

		public void setQueChiLeftUp(String queChiLeftUp) {
			this.queChiLeftUp = queChiLeftUp;
		}

		public String getQueChiRightDown() {
			return queChiRightDown;
		}

		public void setQueChiRightDown(String queChiRightDown) {
			this.queChiRightDown = queChiRightDown;
		}

		public String getQueChiRightUp() {
			return queChiRightUp;
		}

		public void setQueChiRightUp(String queChiRightUp) {
			this.queChiRightUp = queChiRightUp;
		}

		public String getRes0() {
			return res0;
		}

		public void setRes0(String res0) {
			this.res0 = res0;
		}

		public String getRes1() {
			return res1;
		}

		public void setRes1(String res1) {
			this.res1 = res1;
		}

		public String getRes2() {
			return res2;
		}

		public void setRes2(String res2) {
			this.res2 = res2;
		}

		public String getRes3() {
			return res3;
		}

		public void setRes3(String res3) {
			this.res3 = res3;
		}

		public String getRes4() {
			return res4;
		}

		public void setRes4(String res4) {
			this.res4 = res4;
		}

		public String getRes5() {
			return res5;
		}

		public void setRes5(String res5) {
			this.res5 = res5;
		}

		public String getSurgeonName() {
			return surgeonName;
		}

		public void setSurgeonName(String surgeonName) {
			this.surgeonName = surgeonName;
		}

		public String getWzd() {
			return wzd;
		}

		public void setWzd(String wzd) {
			this.wzd = wzd;
		}

		public List<Yfjz> getYfjz() {
			return yfjz;
		}

		public void setYfjz(List<Yfjz> yfjz) {
			this.yfjz = yfjz;
		}

		public String getYiChiLeftDown() {
			return yiChiLeftDown;
		}

		public void setYiChiLeftDown(String yiChiLeftDown) {
			this.yiChiLeftDown = yiChiLeftDown;
		}

		public String getYiChiLeftUp() {
			return yiChiLeftUp;
		}

		public void setYiChiLeftUp(String yiChiLeftUp) {
			this.yiChiLeftUp = yiChiLeftUp;
		}

		public String getYiChiRightDown() {
			return yiChiRightDown;
		}

		public void setYiChiRightDown(String yiChiRightDown) {
			this.yiChiRightDown = yiChiRightDown;
		}

		public String getYiChiRightUp() {
			return yiChiRightUp;
		}

		public void setYiChiRightUp(String yiChiRightUp) {
			this.yiChiRightUp = yiChiRightUp;
		}

		public String getYwjcs() {
			return ywjcs;
		}

		public void setYwjcs(String ywjcs) {
			this.ywjcs = ywjcs;
		}

		public String getYwjys() {
			return ywjys;
		}

		public void setYwjys(String ywjys) {
			this.ywjys = ywjys;
		}

		public String getYwyfjz() {
			return ywyfjz;
		}

		public void setYwyfjz(String ywyfjz) {
			this.ywyfjz = ywyfjz;
		}

		public String getYwyyqk() {
			return ywyyqk;
		}

		public void setYwyyqk(String ywyyqk) {
			this.ywyyqk = ywyyqk;
		}

	}

	public static class HdPersonalHealthAssist {
		private String col0087;// 宫颈涂片异常标志
		private String col0089;// 尿蛋白
		private String col0090;// 尿糖
		private String col0091;// 尿酮体
		private String col0092;// 尿潜血
		private String col0093;// 尿其他检查结果描述
		private String col0094; // 血红蛋白(g/L)
		private String col0095; // 白细胞计数值(109/L)
		private String col0096; // 血小板计数值(109/L)
		private String col0098;// 血常规其他检查结果
		private String col0099;// 血清谷丙转氨酶值（U/L）
		private String col0100;// 血清谷草转氨酶值（U/L）
		private String col0101;// 白蛋白浓度（g/L）
		private String col0103;// 总胆红素值（μmol/L）
		private String col0104;// 结合胆红素值（μmol/L）
		private String col0106;// 血肌酐值(μmol/L)
		private String col0107;// 血尿素氮检测值(mmol／L)
		private String col0108;// 血钾浓度(mmol／L)
		private String col0109;// 血钠浓度(mmol／L)
		private String col0112;// 总胆固醇值(mmol／L)
		private String col0113;// 甘油三酯值(mmol／L)
		private String col0114;// 血清低密度脂蛋白胆固醇检测值(mmol／L)
		private String col0115;// 血清高密度脂蛋白胆固醇检测值(mmol／L)
		private String col0117;// 乙型肝炎病毒表面抗原
		private String col0122;// 空腹血糖值(mmol／L)
		private String col0124;// 糖化血红蛋白值(%)
		private String col0125;// 大便潜血标志
		private String col0128;// 胸部X线检查异常标志
		private String col0129;// 胸部X线检查异常描述
		private String col0130;// 心电图异常标志
		private String col0131;// 心电图异常描述
		private String col0132;// 腹部B超综合检查异常标志
		private String col0133;// B超其他异常标志
		private String col0134;// B超其他异常描述
		private String col0138;// 腹部B超检查异常描述
		private String col0163;// 尿微量白蛋白（mg/dL)
		private String col0164;// 宫颈涂片异常描述
		private String col0198;// 辅助检查其他描述
		private String col0199;// 空腹血糖mg/dl
		private String createorg;// 创建机构
		private String creater;// 创建人
		private String createtime;// 创建时间
		private String res0 = "2";// 新增必填项字段"res0" 数据来源 空为公卫，'1'为手提箱，'2'为PAD。
		private String fromType="2";

		public String getFromType() {
			return fromType;
		}

		public void setFromType(String fromType) {
			this.fromType = fromType;
		}

		public String getRes0() {
			return res0;
		}

		public void setRes0(String res0) {
			this.res0 = res0;
		}

		public String getCol0087() {
			return col0087;
		}

		public void setCol0087(String col0087) {
			this.col0087 = col0087;
		}

		public String getCol0089() {
			return col0089;
		}

		public void setCol0089(String col0089) {
			this.col0089 = col0089;
		}

		public String getCol0090() {
			return col0090;
		}

		public void setCol0090(String col0090) {
			this.col0090 = col0090;
		}

		public String getCol0091() {
			return col0091;
		}

		public void setCol0091(String col0091) {
			this.col0091 = col0091;
		}

		public String getCol0092() {
			return col0092;
		}

		public void setCol0092(String col0092) {
			this.col0092 = col0092;
		}

		public String getCol0093() {
			return col0093;
		}

		public void setCol0093(String col0093) {
			this.col0093 = col0093;
		}

		public String getCol0094() {
			return col0094;
		}

		public void setCol0094(String col0094) {
			this.col0094 = col0094;
		}

		public String getCol0095() {
			return col0095;
		}

		public void setCol0095(String col0095) {
			this.col0095 = col0095;
		}

		public String getCol0096() {
			return col0096;
		}

		public void setCol0096(String col0096) {
			this.col0096 = col0096;
		}

		public String getCol0098() {
			return col0098;
		}

		public void setCol0098(String col0098) {
			this.col0098 = col0098;
		}

		public String getCol0099() {
			return col0099;
		}

		public void setCol0099(String col0099) {
			this.col0099 = col0099;
		}

		public String getCol0100() {
			return col0100;
		}

		public void setCol0100(String col0100) {
			this.col0100 = col0100;
		}

		public String getCol0101() {
			return col0101;
		}

		public void setCol0101(String col0101) {
			this.col0101 = col0101;
		}

		public String getCol0103() {
			return col0103;
		}

		public void setCol0103(String col0103) {
			this.col0103 = col0103;
		}

		public String getCol0104() {
			return col0104;
		}

		public void setCol0104(String col0104) {
			this.col0104 = col0104;
		}

		public String getCol0106() {
			return col0106;
		}

		public void setCol0106(String col0106) {
			this.col0106 = col0106;
		}

		public String getCol0107() {
			return col0107;
		}

		public void setCol0107(String col0107) {
			this.col0107 = col0107;
		}

		public String getCol0108() {
			return col0108;
		}

		public void setCol0108(String col0108) {
			this.col0108 = col0108;
		}

		public String getCol0109() {
			return col0109;
		}

		public void setCol0109(String col0109) {
			this.col0109 = col0109;
		}

		public String getCol0112() {
			return col0112;
		}

		public void setCol0112(String col0112) {
			this.col0112 = col0112;
		}

		public String getCol0113() {
			return col0113;
		}

		public void setCol0113(String col0113) {
			this.col0113 = col0113;
		}

		public String getCol0114() {
			return col0114;
		}

		public void setCol0114(String col0114) {
			this.col0114 = col0114;
		}

		public String getCol0115() {
			return col0115;
		}

		public void setCol0115(String col0115) {
			this.col0115 = col0115;
		}

		public String getCol0117() {
			return col0117;
		}

		public void setCol0117(String col0117) {
			this.col0117 = col0117;
		}

		public String getCol0122() {
			return col0122;
		}

		public void setCol0122(String col0122) {
			this.col0122 = col0122;
		}

		public String getCol0124() {
			return col0124;
		}

		public void setCol0124(String col0124) {
			this.col0124 = col0124;
		}

		public String getCol0125() {
			return col0125;
		}

		public void setCol0125(String col0125) {
			this.col0125 = col0125;
		}

		public String getCol0128() {
			return col0128;
		}

		public void setCol0128(String col0128) {
			this.col0128 = col0128;
		}

		public String getCol0129() {
			return col0129;
		}

		public void setCol0129(String col0129) {
			this.col0129 = col0129;
		}

		public String getCol0130() {
			return col0130;
		}

		public void setCol0130(String col0130) {
			this.col0130 = col0130;
		}

		public String getCol0131() {
			return col0131;
		}

		public void setCol0131(String col0131) {
			this.col0131 = col0131;
		}

		public String getCol0132() {
			return col0132;
		}

		public void setCol0132(String col0132) {
			this.col0132 = col0132;
		}

		public String getCol0133() {
			return col0133;
		}

		public void setCol0133(String col0133) {
			this.col0133 = col0133;
		}

		public String getCol0134() {
			return col0134;
		}

		public void setCol0134(String col0134) {
			this.col0134 = col0134;
		}

		public String getCol0138() {
			return col0138;
		}

		public void setCol0138(String col0138) {
			this.col0138 = col0138;
		}

		public String getCol0163() {
			return col0163;
		}

		public void setCol0163(String col0163) {
			this.col0163 = col0163;
		}

		public String getCol0164() {
			return col0164;
		}

		public void setCol0164(String col0164) {
			this.col0164 = col0164;
		}

		public String getCol0198() {
			return col0198;
		}

		public void setCol0198(String col0198) {
			this.col0198 = col0198;
		}

		public String getCol0199() {
			return col0199;
		}

		public void setCol0199(String col0199) {
			this.col0199 = col0199;
		}

		public String getCreateorg() {
			return createorg;
		}

		public void setCreateorg(String createorg) {
			this.createorg = createorg;
		}

		public String getCreater() {
			return creater;
		}

		public void setCreater(String creater) {
			this.creater = creater;
		}

		public String getCreatetime() {
			return createtime;
		}

		public void setCreatetime(String createtime) {
			this.createtime = createtime;
		}

	}

	private static class HdPersonalHospitalList {
		private String hosName;// 住院医疗机构名称
		private String inDate;// 人院日期
		private String medicalRecord;// 病案号
		private String outDate;// 出院日期
		private String reason;// 入院原因

		public String getHosName() {
			return hosName;
		}

		public void setHosName(String hosName) {
			this.hosName = hosName;
		}

		public String getInDate() {
			return inDate;
		}

		public void setInDate(String inDate) {
			this.inDate = inDate;
		}

		public String getMedicalRecord() {
			return medicalRecord;
		}

		public void setMedicalRecord(String medicalRecord) {
			this.medicalRecord = medicalRecord;
		}

		public String getOutDate() {
			return outDate;
		}

		public void setOutDate(String outDate) {
			this.outDate = outDate;
		}

		public String getReason() {
			return reason;
		}

		public void setReason(String reason) {
			this.reason = reason;
		}

	}

	public static class HdPersonalPharmacyList {
		private String dosage;// 用量
		private String drugName;// 药名名称
		private String medicationCompliance;// 服药依从性
		private String medicationTime;// 用药时间
		private String usage;// 用法

		public String getDosage() {
			return dosage;
		}

		public void setDosage(String dosage) {
			this.dosage = dosage;
		}

		public String getDrugName() {
			return drugName;
		}

		public void setDrugName(String drugName) {
			this.drugName = drugName;
		}

		public String getMedicationCompliance() {
			return medicationCompliance;
		}

		public void setMedicationCompliance(String medicationCompliance) {
			this.medicationCompliance = medicationCompliance;
		}

		public String getMedicationTime() {
			return medicationTime;
		}

		public void setMedicationTime(String medicationTime) {
			this.medicationTime = medicationTime;
		}

		public String getUsage() {
			return usage;
		}

		public void setUsage(String usage) {
			this.usage = usage;
		}

	}

	public static class HdPersonalSickbedList {
		private String hospital;// 建立家庭病床医疗机构名称
		private String medicalRecord;// 病案号
		private String removeDate;// 家庭病床撤床日期
		private String sickbedCause;// 家庭病床建立原因
		private String sickbedDate;// 家庭病床建床日期

		public String getHospital() {
			return hospital;
		}

		public void setHospital(String hospital) {
			this.hospital = hospital;
		}

		public String getMedicalRecord() {
			return medicalRecord;
		}

		public void setMedicalRecord(String medicalRecord) {
			this.medicalRecord = medicalRecord;
		}

		public String getRemoveDate() {
			return removeDate;
		}

		public void setRemoveDate(String removeDate) {
			this.removeDate = removeDate;
		}

		public String getSickbedCause() {
			return sickbedCause;
		}

		public void setSickbedCause(String sickbedCause) {
			this.sickbedCause = sickbedCause;
		}

		public String getSickbedDate() {
			return sickbedDate;
		}

		public void setSickbedDate(String sickbedDate) {
			this.sickbedDate = sickbedDate;
		}

	}

	public static class Yfjz {
		private String bacterinName;// 疫苗
		private String immuDate;// 接种日期
		private String immuOrgan;// 接种单位

		public String getBacterinName() {
			return bacterinName;
		}

		public void setBacterinName(String bacterinName) {
			this.bacterinName = bacterinName;
		}

		public String getImmuDate() {
			return immuDate;
		}

		public void setImmuDate(String immuDate) {
			this.immuDate = immuDate;
		}

		public String getImmuOrgan() {
			return immuOrgan;
		}

		public void setImmuOrgan(String immuOrgan) {
			this.immuOrgan = immuOrgan;
		}

	}

	public static class HdPersonalAbstract {
		private String chemie;// 化学物质
		private String chemieStep;// 化学物质防护措施
		private String drink;// 饮酒频率代码
		private String drinkAge;// 开始饮酒年龄（岁）
		private String drinkNum;// 折合白酒日饮量（两）
		private String drinkOther;// 饮酒种类其他
		private String drinkType;// 饮酒种类代码组合
		private String drunk;// 醉酒标志
		private String dust;// 粉尘
		private String dustStep;// 粉尘防护措施
		private String emit;// 放射物质
		private String emitStep;// 放射物质防护措施
		private String exposeState;// 职业暴露情况
		private String exposeYear;// 累计暴露年限（年）
		private String foodHabits;// 饮食习惯
		private String hazardsBio;// 职业暴露危险因素
		private String nodrink;// 是否戒酒
		private String nodrinkAge;// 戒酒年龄（岁）
		private String other;// 其它内容
		private String otherStep;// 其它防护措施
		private String phy;// 物理因素
		private String phyStep;// 物理因素防护措施
		private String smoke;// 吸烟状况代码
		private String smokeAgee;// 戒烟年龄（岁）
		private String smokeAges;// 开始吸烟年龄（岁）
		private String smokeNum;// 日吸烟量（支）
		private String trainingRate;// 运动频率代码
		private String trainingTime;// 每次锻炼时间（分钟）
		private String trainingTotaltime;// 坚持锻炼时间（年）
		private String trainingWay;// 运动方式说明

		public String getChemie() {
			return chemie;
		}

		public void setChemie(String chemie) {
			this.chemie = chemie;
		}

		public String getChemieStep() {
			return chemieStep;
		}

		public void setChemieStep(String chemieStep) {
			this.chemieStep = chemieStep;
		}

		public String getDrink() {
			return drink;
		}

		public void setDrink(String drink) {
			this.drink = drink;
		}

		public String getDrinkAge() {
			return drinkAge;
		}

		public void setDrinkAge(String drinkAge) {
			this.drinkAge = drinkAge;
		}

		public String getDrinkNum() {
			return drinkNum;
		}

		public void setDrinkNum(String drinkNum) {
			this.drinkNum = drinkNum;
		}

		public String getDrinkOther() {
			return drinkOther;
		}

		public void setDrinkOther(String drinkOther) {
			this.drinkOther = drinkOther;
		}

		public String getDrinkType() {
			return drinkType;
		}

		public void setDrinkType(String drinkType) {
			this.drinkType = drinkType;
		}

		public String getDrunk() {
			return drunk;
		}

		public void setDrunk(String drunk) {
			this.drunk = drunk;
		}

		public String getDust() {
			return dust;
		}

		public void setDust(String dust) {
			this.dust = dust;
		}

		public String getDustStep() {
			return dustStep;
		}

		public void setDustStep(String dustStep) {
			this.dustStep = dustStep;
		}

		public String getEmit() {
			return emit;
		}

		public void setEmit(String emit) {
			this.emit = emit;
		}

		public String getEmitStep() {
			return emitStep;
		}

		public void setEmitStep(String emitStep) {
			this.emitStep = emitStep;
		}

		public String getExposeState() {
			return exposeState;
		}

		public void setExposeState(String exposeState) {
			this.exposeState = exposeState;
		}

		public String getExposeYear() {
			return exposeYear;
		}

		public void setExposeYear(String exposeYear) {
			this.exposeYear = exposeYear;
		}

		public String getFoodHabits() {
			return foodHabits;
		}

		public void setFoodHabits(String foodHabits) {
			this.foodHabits = foodHabits;
		}

		public String getHazardsBio() {
			return hazardsBio;
		}

		public void setHazardsBio(String hazardsBio) {
			this.hazardsBio = hazardsBio;
		}

		public String getNodrink() {
			return nodrink;
		}

		public void setNodrink(String nodrink) {
			this.nodrink = nodrink;
		}

		public String getNodrinkAge() {
			return nodrinkAge;
		}

		public void setNodrinkAge(String nodrinkAge) {
			this.nodrinkAge = nodrinkAge;
		}

		public String getOther() {
			return other;
		}

		public void setOther(String other) {
			this.other = other;
		}

		public String getOtherStep() {
			return otherStep;
		}

		public void setOtherStep(String otherStep) {
			this.otherStep = otherStep;
		}

		public String getPhy() {
			return phy;
		}

		public void setPhy(String phy) {
			this.phy = phy;
		}

		public String getPhyStep() {
			return phyStep;
		}

		public void setPhyStep(String phyStep) {
			this.phyStep = phyStep;
		}

		public String getSmoke() {
			return smoke;
		}

		public void setSmoke(String smoke) {
			this.smoke = smoke;
		}

		public String getSmokeAgee() {
			return smokeAgee;
		}

		public void setSmokeAgee(String smokeAgee) {
			this.smokeAgee = smokeAgee;
		}

		public String getSmokeAges() {
			return smokeAges;
		}

		public void setSmokeAges(String smokeAges) {
			this.smokeAges = smokeAges;
		}

		public String getSmokeNum() {
			return smokeNum;
		}

		public void setSmokeNum(String smokeNum) {
			this.smokeNum = smokeNum;
		}

		public String getTrainingRate() {
			return trainingRate;
		}

		public void setTrainingRate(String trainingRate) {
			this.trainingRate = trainingRate;
		}

		public String getTrainingTime() {
			return trainingTime;
		}

		public void setTrainingTime(String trainingTime) {
			this.trainingTime = trainingTime;
		}

		public String getTrainingTotaltime() {
			return trainingTotaltime;
		}

		public void setTrainingTotaltime(String trainingTotaltime) {
			this.trainingTotaltime = trainingTotaltime;
		}

		public String getTrainingWay() {
			return trainingWay;
		}

		public void setTrainingWay(String trainingWay) {
			this.trainingWay = trainingWay;
		}

	}

	/**
	 * 解析数据
	 * 
	 * @param context
	 * @return
	 */
	public static List<HealthCheck> convertData(Context context) {
		List<HealthCheck> healthCheckList = new ArrayList<>();
		HealthCheck healthCheck = null;
		HdPersonalHealth hdPersonalHealth = null;
		HdPersonalHealthAssist hdPersonalHealthAssist = null;

		List<ARCHIVE_CUSTOMERBASEINFO> baseinfos = FDbManager.getInstance(context).findAllByWhere(
				ARCHIVE_CUSTOMERBASEINFO.class, "IS_UPDATE is not 'N'" + "AND CREATEORG='" + NovaApplication.getJgbh() + "'");// 健康体检_客户体检基本信息(症状)
//		List<ARCHIVE_CUSTOMERBASEINFO> baseinfos = FDbManager.getInstance(context)
//				.findAllByWhere(ARCHIVE_CUSTOMERBASEINFO.class, "IS_UPDATE='" + "Y'");// 健康体检_客户体检基本信息(症状)

		for (ARCHIVE_CUSTOMERBASEINFO baseinfo : baseinfos) {
			String idcard = baseinfo.getIDCARD();
			healthCheck = new HealthCheck();
			hdPersonalHealth = new HdPersonalHealth();
			hdPersonalHealthAssist = new HdPersonalHealthAssist();
			hdPersonalHealth.setFromType("2");
			hdPersonalHealthAssist.setFromType("2");

			List<ARCHIVE_CUSTOMERBASEINFO> customerbaseinfos = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_CUSTOMERBASEINFO.class, "IDCARD = '" + idcard + "'");
			List<ARCHIVE_GENERALCONDITION> generalconditions = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_GENERALCONDITION.class, "IDCARD = '" + idcard + "'");// 健康体检_一般状况(基本信息和老年人评估)
			List<ARCHIVE_LIFESTYLE> lifestyles = FDbManager.getInstance(context).findAllByWhere(ARCHIVE_LIFESTYLE.class,
					"IDCARD = '" + idcard + "'");// 健康体检_生活方式
			List<ARCHIVE_ASSISTCHECK> assistchecks = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_ASSISTCHECK.class, "IDCARD = '" + idcard + "'");// 健康体检_辅助检查

			List<OLD_MEDICINE_CN> old_medicine_cn = FDbManager.getInstance(context)
					.findAllByWhere(OLD_MEDICINE_CN.class, "IDCARD = '" + idcard + "'");// 老年人中医体质辨识

			List<OLD_MEDICINE_RESULT> medicineResults = FDbManager.getInstance(context)
					.findAllByWhere(OLD_MEDICINE_RESULT.class, " IDCARD = '" + idcard + "'");// 健康体检_中医体质

			List<ARCHIVE_ASSESSMENTGUIDE> assessmentguides = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_ASSESSMENTGUIDE.class, "IDCARD = '" + idcard + "'");// 健康评价_健康评价与指导

			List<ARCHIVE_VISCERAFUNCTION> viscerafunctions = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_VISCERAFUNCTION.class, " IDCARD = '" + idcard + "'");// 健康体检_脏器功能表
			List<ARCHIVE_INOCULATIONHISTORY> inoculationhistorys = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_INOCULATIONHISTORY.class, " IDCARD = '" + idcard + "'");// 健康评价_非免疫规划预防接种史
			List<ARCHIVE_FAMILYBEDHISTORY> familybedhistorys = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_FAMILYBEDHISTORY.class, " IDCARD = '" + idcard + "'");// 治疗情况_家庭病床史
			List<ARCHIVE_HOSPITALHISTORY> hospitalhistorys = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_HOSPITALHISTORY.class, " IDCARD = '" + idcard + "'");// 治疗情况_住院史
			List<ARCHIVE_MEDICATION> medications = FDbManager.getInstance(context)
					.findAllByWhere(ARCHIVE_MEDICATION.class, " IDCARD = '" + idcard + "'");// 治疗情况_用药情况

			// healthCheck.setQdqxz(qdqxz);//缺项值

			if (customerbaseinfos.size() > 0) {
				ARCHIVE_CUSTOMERBASEINFO customerbaseinfo = customerbaseinfos.get(0);

				hdPersonalHealth.setCardid(TextUtils.isEmpty(customerbaseinfo.getIDCARD())?"":customerbaseinfo.getIDCARD().toUpperCase());// 居民身份证/健康卡号
				hdPersonalHealth.setCol0001(customerbaseinfo.getSYMPTOM());// 主要症状代码组合
				hdPersonalHealth.setCol0002(customerbaseinfo.getOTHER());// 其他症状描述

				hdPersonalHealth.setHappentime(customerbaseinfo.getCHECKDATE() == null ? ""
						: GlobalConts.dateFormat.format(customerbaseinfo.getCHECKDATE()));

				hdPersonalHealth.setSurgeonName(customerbaseinfo.getDOCTOR());

				List<ARCHIVE_PHYSICALEXAM> physicalexams = FDbManager.getInstance(context)
						.findAllByWhere(ARCHIVE_PHYSICALEXAM.class, " IDCARD = '" + idcard + "'");// 健康体检_查体信息

				if (physicalexams.size() > 0) {
					// 查体信息
					ARCHIVE_PHYSICALEXAM physicalexam = physicalexams.get(0);

					hdPersonalHealth.setCol0031(physicalexam.getEYEROUND());// 眼底检查结果代码
					hdPersonalHealth.setCol0034(physicalexam.getSCLERA());// 巩膜检查结果
					hdPersonalHealth.setCol0035(physicalexam.getEYEROUND_EX());// 眼检查异常描述

					hdPersonalHealth.setCol0052(physicalexam.getSKIN());// 皮肤检查结果代码
					hdPersonalHealth.setCol0053(physicalexam.getBREAST());// 乳腺检查结果代码
					hdPersonalHealth.setCol0054(physicalexam.getFOOTBACK());// 足背动脉搏动代码
					hdPersonalHealth.setCol0059(physicalexam.getLYMPH());// 淋巴结检查结果代码
					hdPersonalHealth.setCol0060(physicalexam.getEDEMA());// 下肢水肿检查结果代码
					hdPersonalHealth.setCol0061(physicalexam.getANUS());// 肛门指诊检查结果代码
					hdPersonalHealth.setCol0066(physicalexam.getRALE());// 肺部罗音代码
					hdPersonalHealth.setCol0067(physicalexam.getBREATHSOUNDS());// 肺部异常呼吸音标志
					hdPersonalHealth.setCol0068(physicalexam.getVOICED());// 腹部移动性浊音标志
					hdPersonalHealth.setCol0069(physicalexam.getPRESSPAIN());// 腹部压痛标志
					hdPersonalHealth.setCol0070(physicalexam.getENCLOSEDMASS());// 腹部包块标志
					hdPersonalHealth.setCol0072(physicalexam.getLIVER());// 肝大标志
					hdPersonalHealth.setCol0073(physicalexam.getSPLEEN());// 脾大标志
					hdPersonalHealth.setCol0075(physicalexam.getHEARTRATE());// 心率(次/min)
					hdPersonalHealth.setCol0076(physicalexam.getHEARTRHYTHM());// 心律类别代码
					hdPersonalHealth.setCol0077(physicalexam.getNOISE());// 心脏杂音标志
					hdPersonalHealth.setCol0082(physicalexam.getVULVA());// 外阴异常标志
					hdPersonalHealth.setCol0083(physicalexam.getVAGINA());// 阴道检查结果代码
					hdPersonalHealth.setCol0084(physicalexam.getCERVIXUTERI());// 宫颈检查结果代码
					hdPersonalHealth.setCol0085(physicalexam.getCORPUS());// 宫体检查结果代码
					hdPersonalHealth.setCol0086(physicalexam.getATTACH());// 附件异常标志

					hdPersonalHealth.setCol0146(physicalexam.getBARRELCHEST());// 桶状胸标志
					hdPersonalHealth.setCol0147(physicalexam.getBREATHSOUNDS_EX());// 肺部异常呼吸音描述
					hdPersonalHealth.setCol0148(physicalexam.getRALE_EX());// 肺部罗音描述
					hdPersonalHealth.setCol0149(physicalexam.getPRESSPAIN_EX());// 腹部压痛描述
					hdPersonalHealth.setCol0150(physicalexam.getENCLOSEDMASS_EX());// 腹部包块描述
					hdPersonalHealth.setCol0151(physicalexam.getLIVER_EX());// VARCHAR2(100)
					// 肝大描述
					hdPersonalHealth.setCol0152(physicalexam.getSPLEEN_EX());// 脾大描述
					hdPersonalHealth.setCol0153(physicalexam.getVOICED_EX());// 腹部移动性浊音描述
					hdPersonalHealth.setCol0154(physicalexam.getANUS_EX());// 肛门指诊其它
					hdPersonalHealth.setCol0156(physicalexam.getVULVA_EX());// 外阴异常描述
					hdPersonalHealth.setCol0157(physicalexam.getVAGINA_EX());// 阴道异常描述
					hdPersonalHealth.setCol0158(physicalexam.getCERVIXUTERI_EX());// 宫颈异常描述
					hdPersonalHealth.setCol0159(physicalexam.getCORPUS_EX());// 宫体异常描述
					hdPersonalHealth.setCol0160(physicalexam.getATTACH_EX());// 附件异常描述
					hdPersonalHealth.setCol0161(physicalexam.getOTHER());// 其他查体结果
					// --健康体检--查体信息

					hdPersonalHealth.setCol0195(physicalexam.getSCLERE_EX());// 巩膜其他描述
					hdPersonalHealth.setCol0196(physicalexam.getLYMPH_EX());// 淋巴结其他描述
					hdPersonalHealth.setCol0197(physicalexam.getNOISE_EX());// 心脏杂音其他描述

					hdPersonalHealth.setRes0(physicalexam.getSKIN_EX());
					hdPersonalHealth.setRes1(physicalexam.getBREAST_EX());
				}

				List<ARCHIVE_HEALTHQUESTION> healthquestions = FDbManager.getInstance(context)
						.findAllByWhere(ARCHIVE_HEALTHQUESTION.class, " IDCARD = '" + idcard + "'");// 健康体检_健康问题
				if (healthquestions.size() > 0) {
					ARCHIVE_HEALTHQUESTION healthquestion = healthquestions.get(0);
					hdPersonalHealth.setCol0174(healthquestion.getBRAIN_DIS());// 脑血管疾病
					hdPersonalHealth.setCol0175(healthquestion.getBRAIN_OTHER());// 脑血管疾病其它
					hdPersonalHealth.setCol0176(healthquestion.getRENAL_DIS());// 肾脏疾病
					hdPersonalHealth.setCol0177(healthquestion.getRENAL_OTHER());// 肾脏疾病其他
					hdPersonalHealth.setCol0178(healthquestion.getHEART_DIS());// 心脏疾病
					hdPersonalHealth.setCol0179(healthquestion.getHEART_OTHER());// 心脏疾病其他
					hdPersonalHealth.setCol0180(healthquestion.getVESSEL_DIS());// 血管疾病
					hdPersonalHealth.setCol0181(healthquestion.getVESSEL_OTHER());// 血管疾病其他
					hdPersonalHealth.setCol0182(healthquestion.getEYE_DIS());// 眼部疾病
					hdPersonalHealth.setCol0183(healthquestion.getEYE_OTHER());// 眼部疾病其他
					hdPersonalHealth.setCol0184(healthquestion.getNERVE_DIS());// 神经系统疾病
					hdPersonalHealth.setCol0185(healthquestion.getNERVE_DIS_OTHER());// 有神经系统疾病
					hdPersonalHealth.setCol0186(healthquestion.getELSE_DIS());// 其他系统疾病
					hdPersonalHealth.setCol0187(healthquestion.getELSE_DIS_OTHER());// VARCHAR2(40)

				}

			}

			hdPersonalHealth.setYwyyqk("DM01-11_1");
			if (medications.size() > 0) {
				// 用药情况
				List<HdPersonalPharmacyList> list = new ArrayList<HdPersonalPharmacyList>();
				for (int i = 0; i < medications.size(); i++) {
					ARCHIVE_MEDICATION medication = medications.get(i);
					if (!TextUtils.isEmpty(medication.getUSENUM()) && !TextUtils.isEmpty(medication.getMEDICINALNAME())
							&& !TextUtils.isEmpty(medication.getPILLDEPENDENCE())
							&& !TextUtils.isEmpty(medication.getSTARTTIME())
							&& !TextUtils.isEmpty(medication.getUSEAGE())
							&& !TextUtils.isEmpty(medication.getMEDICINALNAME())) { // TODO
																					// 0
						HdPersonalPharmacyList hdPersonalPharmacyList = new HdPersonalPharmacyList();
						hdPersonalPharmacyList.setDosage(medication.getUSENUM());
						hdPersonalPharmacyList.setDrugName(medication.getMEDICINALNAME());
						hdPersonalPharmacyList.setMedicationCompliance(medication.getPILLDEPENDENCE());
						hdPersonalPharmacyList.setMedicationTime(medication.getSTARTTIME());
						hdPersonalPharmacyList.setUsage(medication.getUSEAGE());
						if (TextUtils.isEmpty(medication.getMEDICINALNAME())) {
							continue;
						}
						hdPersonalHealth.setYwyyqk("DM01-11_2");
						list.add(hdPersonalPharmacyList);
					}
				}
				hdPersonalHealth.setHdPersonalPharmacyList(list);

			} else {
				hdPersonalHealth.setHdPersonalPharmacyList(new ArrayList());
			}

			hdPersonalHealth.setYwjys("DM01-11_1");
			if (hospitalhistorys.size() > 0) {
				// 住院史
				List<HdPersonalHospitalList> list = new ArrayList<HdPersonalHospitalList>();

				for (int i = 0; i < hospitalhistorys.size(); i++) {
					ARCHIVE_HOSPITALHISTORY hospitalhistory = hospitalhistorys.get(i);
					if (!TextUtils.isEmpty(hospitalhistory.getHOSPITALNAME())
							&& hospitalhistory.getINHOSPITALDATE() != null
							&& hospitalhistory.getOUTHOSPITALDATE() != null
							&& !TextUtils.isEmpty(hospitalhistory.getILLCASENUM())
							&& !TextUtils.isEmpty(hospitalhistory.getREASON())) {// TODO
						// 1
						HdPersonalHospitalList hdPersonalHospitalList = new HdPersonalHospitalList();
						hdPersonalHospitalList.setHosName((hospitalhistory.getHOSPITALNAME()));
						hdPersonalHospitalList.setInDate(hospitalhistory.getINHOSPITALDATE() == null ? ""
								: GlobalConts.dateFormat.format(hospitalhistory.getINHOSPITALDATE()));
						hdPersonalHospitalList.setOutDate(hospitalhistory.getOUTHOSPITALDATE() == null ? ""
								: GlobalConts.dateFormat.format(hospitalhistory.getOUTHOSPITALDATE()));
						hdPersonalHospitalList.setMedicalRecord(hospitalhistory.getILLCASENUM());
						hdPersonalHospitalList.setReason(hospitalhistory.getREASON());
						hdPersonalHealth.setYwjys("DM01-11_2");
						list.add(hdPersonalHospitalList);
					}
				}
				hdPersonalHealth.setHdPersonalHospitalList(list);
			} else {
				hdPersonalHealth.setHdPersonalHospitalList(new ArrayList());
			}

			hdPersonalHealth.setYwjcs("DM01-11_1");
			if (familybedhistorys.size() > 0) {
				// 家庭病床史
				List<HdPersonalSickbedList> list = new ArrayList<HdPersonalSickbedList>();
				for (int i = 0; i < familybedhistorys.size(); i++) {
					ARCHIVE_FAMILYBEDHISTORY familybedhistory = familybedhistorys.get(i);
					if (!TextUtils.isEmpty(familybedhistory.getHOSPITALNAME())
							&& !TextUtils.isEmpty(familybedhistory.getILLCASENUMS())
							&& familybedhistory.getOUTHOSPITALDATE() != null
							&& !TextUtils.isEmpty(familybedhistory.getREASONS())
							&& familybedhistory.getINHOSPITALDATE() != null) {// TODO
																				// 2
						HdPersonalSickbedList hdPersonalSickbedList = new HdPersonalSickbedList();
						hdPersonalSickbedList.setHospital(familybedhistory.getHOSPITALNAME());
						hdPersonalSickbedList.setMedicalRecord(familybedhistory.getILLCASENUMS());
						hdPersonalSickbedList.setRemoveDate(familybedhistory.getOUTHOSPITALDATE() == null ? ""
								: GlobalConts.dateFormat.format(familybedhistory.getOUTHOSPITALDATE()));
						hdPersonalSickbedList.setSickbedCause(familybedhistory.getREASONS());
						hdPersonalSickbedList.setSickbedDate(familybedhistory.getINHOSPITALDATE() == null ? ""
								: GlobalConts.dateFormat.format(familybedhistory.getINHOSPITALDATE()));

						hdPersonalHealth.setYwjcs("DM01-11_2");
						list.add(hdPersonalSickbedList);
					}
				}
				hdPersonalHealth.setHdPersonalSickbedList(list);

			} else {
				hdPersonalHealth.setHdPersonalSickbedList(new ArrayList());
			}

			hdPersonalHealth.setYwyfjz("DM01-11_1");
			if (inoculationhistorys.size() > 0) {
				// 健康体检_非免疫规划预防接种史
				List<Yfjz> yfjzList = new ArrayList<>();
				for (int i = 0; i < inoculationhistorys.size(); i++) {
					ARCHIVE_INOCULATIONHISTORY inoculationhistory = inoculationhistorys.get(i);
					if (!TextUtils.isEmpty(inoculationhistory.getPILLNAME())
							&& inoculationhistory.getINOCULATIONDATE() != null
							&& !TextUtils.isEmpty(inoculationhistory.getINOCULATIONHISTORY())) {// TODO
																								// 3
						Yfjz yfjz = new Yfjz();
						yfjz.setBacterinName(inoculationhistory.getPILLNAME());
						yfjz.setImmuDate(inoculationhistory.getINOCULATIONDATE() == null ? ""
								: GlobalConts.dateFormat.format(inoculationhistory.getINOCULATIONDATE()));
						yfjz.setImmuOrgan(inoculationhistory.getINOCULATIONHISTORY());
						if (TextUtils.isEmpty(inoculationhistory.getINOCULATIONHISTORY())) {
							continue;
						}
						hdPersonalHealth.setYwyfjz("DM01-11_2");
						yfjzList.add(yfjz);
					}
				}
				hdPersonalHealth.setYfjz(yfjzList);
			} else {
				hdPersonalHealth.setYfjz(new ArrayList());
			}

			if (viscerafunctions.size() > 0) {
				ARCHIVE_VISCERAFUNCTION viscerafunction = viscerafunctions.get(0);

				hdPersonalHealth.setCol0036(viscerafunction.getLISTEN());// 听力检测结果代码
				hdPersonalHealth.setCol0046(viscerafunction.getLIPS());// 口唇外观检查结果代码
				hdPersonalHealth.setCol0055(viscerafunction.getSPORTFUNCTION());// 运动功能状态代码
				hdPersonalHealth.setCol0024(viscerafunction.getTOOTHRESIDES());// 齿列类别代码
				hdPersonalHealth.setCol0026(viscerafunction.getPHARYNGEAL());// 咽部检査结果代码
				hdPersonalHealth.setCol0027(viscerafunction.getLEFTVIEW());// 左眼裸眼远视力值
				hdPersonalHealth.setCol0028(viscerafunction.getRIGHTVIEW());// 右眼裸眼远视力值
				hdPersonalHealth.setCol0029(viscerafunction.getLEFTEYECORRECT());// 左眼矫正远视力值
				hdPersonalHealth.setCol0030(viscerafunction.getRIGHTEYECORRECT());// 右眼矫正远视力值

				// hdPersonalHealth.setCol0047 (archiveViscerafunction);//
				// 龋齿数（颗）
				// hdPersonalHealth.setCol0048 (archiveViscerafunction);//缺齿数（颗）
				// hdPersonalHealth.setCol0049 (archiveViscerafunction);//
				// NUMBER(2)义齿数（颗）

				hdPersonalHealth.setQuChiLeftDown(viscerafunction.getQUCHILEFTDOWN());
				hdPersonalHealth.setQuChiLeftUp(viscerafunction.getQUCHILEFTUP());
				hdPersonalHealth.setQuChiRightDown(viscerafunction.getQUCHIRIGHTDOWN());
				hdPersonalHealth.setQuChiRightUp(viscerafunction.getQUCHIRIGHTUP());

				hdPersonalHealth.setQueChiLeftDown(viscerafunction.getQUECHILEFTDOWN());
				hdPersonalHealth.setQueChiLeftUp(viscerafunction.getQUECHILEFTUP());
				hdPersonalHealth.setQueChiRightDown(viscerafunction.getQUECHIRIGHTDOWN());
				hdPersonalHealth.setQueChiRightUp(viscerafunction.getQUECHIRIGHTUP());

				hdPersonalHealth.setYiChiLeftDown(viscerafunction.getYICHILEFTDOWN());
				hdPersonalHealth.setYiChiLeftUp(viscerafunction.getYICHILEFTUP());
				hdPersonalHealth.setYiChiRightDown(viscerafunction.getYICHIRIGHTDOWN());
				hdPersonalHealth.setYiChiRightUp(viscerafunction.getYICHIRIGHTUP());
			}

			if (generalconditions.size() > 0) {
				ARCHIVE_GENERALCONDITION generalcondition = generalconditions.get(0);
				// hdPersonalHealth.setCol0003 ();// VARCHAR2(100) 患病情况描述
				hdPersonalHealth.setCol0004(generalcondition.getOLD_HEALTHSTATUS());// 老年健康自评代码
				hdPersonalHealth.setCol0005(generalcondition.getOLD_SELFCAREABILITY());// 老年自理能力评估
				hdPersonalHealth.setCol0006(generalcondition.getOLD_RECOGNISE());// 老年认知初筛结果
				hdPersonalHealth.setCol0007(generalcondition.getINTELSCORE());// 老年认知功能评分
				hdPersonalHealth.setCol0008(generalcondition.getOLD_EMOTION());// 老年情感初筛结果
				hdPersonalHealth.setCol0009(generalcondition.getGLOOMYSCORE());// 老年人抑郁评分
				hdPersonalHealth.setCol0010(generalcondition.getHEIGHT());// 身高(cm)
				hdPersonalHealth.setCol0011(generalcondition.getWEIGHT());// 体重（kg）
				// hdPersonalHealth.setCol0012 (generalcondition.get);// 臀围(cm)
				hdPersonalHealth.setCol0013(generalcondition.getWAISTLINE());// 腰围(cm)
				hdPersonalHealth.setCol0014(generalcondition.getTEM());// 体温(℃)
				hdPersonalHealth.setCol0015(generalcondition.getPULSERATE());// 脉率
				hdPersonalHealth.setCol0016(generalcondition.getBREATH_RATE());// 呼吸频率（次/分钟）
				// hdPersonalHealth.setCol0017(generalcondition.get);//
				// 收缩压(mmHg)//不需要传
				// hdPersonalHealth.setCol0018(generalcondition.get);//
				// 舒张压(mmHg)//不需要传
				hdPersonalHealth.setCol0019(generalcondition.getLEFTHEIGHT());// 左侧收缩压（mmHg)
				hdPersonalHealth.setCol0020(generalcondition.getLEFTPRE());// 左侧舒张压（mmHg)
				hdPersonalHealth.setCol0021(generalcondition.getRIGHTHEIGHT());// 右侧收缩压（mmHg)
				hdPersonalHealth.setCol0022(generalcondition.getRIGHTPRE());// 右侧舒张压（mmHg)
				hdPersonalHealth.setCol0023(generalcondition.getBMI());// NUMBER
																		// 体质指数

			}

			if (lifestyles.size() > 0) {
				// 生活方式
				ARCHIVE_LIFESTYLE lifestyle = lifestyles.get(0);
				hdPersonalHealth.setChemie(lifestyle.getCHEM());// 化学物质

				hdPersonalHealth.setDust(lifestyle.getDUSTPROTECT());
				hdPersonalHealth.setEmit(lifestyle.getFANGSHEPROTECT());
				hdPersonalHealth.setFromType("2");
				hdPersonalHealth.setOther(lifestyle.getOTHERPROTECT_EX());
				hdPersonalHealth.setPhy(lifestyle.getPHYSICALPROTECT_EX());

				HdPersonalAbstract hdPersonalAbstract = new HdPersonalAbstract();
				hdPersonalAbstract.setChemie(lifestyle.getCHEM());
				hdPersonalAbstract.setChemieStep(lifestyle.getCHEMPROTECT_EX());
				hdPersonalAbstract.setDrink(lifestyle.getDRINKRATE());
				hdPersonalAbstract.setDrinkAge(lifestyle.getDRINKSTARTAGE());
				hdPersonalAbstract.setDrinkNum(lifestyle.getDAYDRINKVOLUME());
				hdPersonalAbstract.setDrinkOther(lifestyle.getDRINKTYPE_OTHER());
				hdPersonalAbstract.setDrinkType(lifestyle.getDRINKTYPE());
				hdPersonalAbstract.setDrunk(lifestyle.getDRINKTHISYEAR());
				hdPersonalAbstract.setDust(lifestyle.getDUST());
				hdPersonalAbstract.setDustStep(lifestyle.getDUSTPROTECT_EX());
				hdPersonalAbstract.setEmit(lifestyle.getFANGSHE());
				hdPersonalAbstract.setEmitStep(lifestyle.getFANGSHEPROTECT_EX());
				hdPersonalAbstract.setExposeState(lifestyle.getWORKTYPE());
				hdPersonalAbstract.setExposeYear(lifestyle.getWORKTIME());
				hdPersonalAbstract.setFoodHabits(lifestyle.getEATHOBBY());
				hdPersonalAbstract.setHazardsBio(lifestyle.getCAREERHARMFACTORHISTORY());
				hdPersonalAbstract.setNodrink(lifestyle.getISDRINKFORBIDDON());
				hdPersonalAbstract.setNodrinkAge(lifestyle.getFORBIDDONAGE());
				hdPersonalAbstract.setOther(lifestyle.getOTHER());
				hdPersonalAbstract.setOtherStep(lifestyle.getOTHERPROTECT_EX());
				hdPersonalAbstract.setPhy(lifestyle.getPHYSICAL());
				hdPersonalAbstract.setPhyStep(lifestyle.getPHYSICALPROTECT_EX());// 物理因素防护措施
				hdPersonalAbstract.setSmoke(lifestyle.getSMOKECONDITION());
				hdPersonalAbstract.setSmokeAgee(lifestyle.getSMOKEAGEFORBIDDON());
				hdPersonalAbstract.setSmokeAges(lifestyle.getSMOKEAGESTART());
				hdPersonalAbstract.setSmokeNum(lifestyle.getSMOKEDAYNUM());
				hdPersonalAbstract.setTrainingRate(lifestyle.getEXERCISERATE());
				hdPersonalAbstract.setTrainingTime(lifestyle.getEXERCISETIME());
				hdPersonalAbstract.setTrainingTotaltime(lifestyle.getEXCISEPERSISTTIME());
				hdPersonalAbstract.setTrainingWay(lifestyle.getEXERCISEEXISTENSE());
				hdPersonalHealth.setHdPersonalAbstract(hdPersonalAbstract);
				// 接种日期
			} else {
				hdPersonalHealth.setHdPersonalAbstract(new HdPersonalAbstract());
			}

			if (assistchecks.size() > 0) {
				ARCHIVE_ASSISTCHECK assistcheck = assistchecks.get(0);

				hdPersonalHealthAssist.setCol0087(assistcheck.getCERVIX());
				hdPersonalHealthAssist.setCol0089(assistcheck.getPRO());
				hdPersonalHealthAssist.setCol0090(assistcheck.getGLU());
				hdPersonalHealthAssist.setCol0091(assistcheck.getKET());
				hdPersonalHealthAssist.setCol0092(assistcheck.getBLD());
				hdPersonalHealthAssist.setCol0093(assistcheck.getURINE_OTHER());
				hdPersonalHealthAssist.setCol0094(assistcheck.getHB());
				hdPersonalHealthAssist.setCol0095(assistcheck.getWBC());
				hdPersonalHealthAssist.setCol0096(assistcheck.getPLT());
				hdPersonalHealthAssist.setCol0098(assistcheck.getBLOOD_OTHER());
				hdPersonalHealthAssist.setCol0099(assistcheck.getSGPT());
				hdPersonalHealthAssist.setCol0100(assistcheck.getGOT());

				hdPersonalHealthAssist.setCol0101(assistcheck.getBP());// 白蛋白浓度（g/L）
				hdPersonalHealthAssist.setCol0103(assistcheck.getTBIL());// 总胆红素值（μmol/L）
				hdPersonalHealthAssist.setCol0104(assistcheck.getCB());// 结合胆红素值（μmol/L）
				hdPersonalHealthAssist.setCol0106(assistcheck.getSCR()); // 血肌酐值(μmol/L)
				hdPersonalHealthAssist.setCol0107(assistcheck.getBUN());// 血尿素氮检测值(mmol／L)
				hdPersonalHealthAssist.setCol0108(assistcheck.getPC());// 血钾浓度(mmol／L)
				hdPersonalHealthAssist.setCol0109(assistcheck.getHYPE());// 血钠浓度(mmol／L)
				hdPersonalHealthAssist.setCol0112(assistcheck.getTC());// 总胆固醇值(mmol／L)
				hdPersonalHealthAssist.setCol0113(assistcheck.getTG());// 甘油三酯值(mmol／L)
				hdPersonalHealthAssist.setCol0114(assistcheck.getLOW_CHO());// 血清低密度脂蛋白胆固醇检测值(mmol／L)
				hdPersonalHealthAssist.setCol0115(assistcheck.getHEI_CHO());// 血清高密度脂蛋白胆固醇检测值(mmol／L)
				hdPersonalHealthAssist.setCol0117(assistcheck.getHBSAG());// 乙型肝炎病毒表面抗原
				hdPersonalHealthAssist.setCol0122(assistcheck.getFPGL());// 空腹血糖值(mmol／L)

				hdPersonalHealthAssist.setCol0124(assistcheck.getHBALC());// 糖化血红蛋白值(%)
				hdPersonalHealthAssist.setCol0125(assistcheck.getFOB());// 大便潜血标志
				hdPersonalHealthAssist.setCol0128(assistcheck.getCHESTX());// 胸部X线检查异常标志
				hdPersonalHealthAssist.setCol0129(assistcheck.getCHESTX_EX());// 胸部X线检查异常描述
				hdPersonalHealthAssist.setCol0130(assistcheck.getECG());// 心电图异常标志
				hdPersonalHealthAssist.setCol0131(assistcheck.getECG_EX());// 心电图异常描述
				hdPersonalHealthAssist.setCol0132(assistcheck.getFbBchao());// 腹部B超综合检查异常标志
				hdPersonalHealthAssist.setCol0133(assistcheck.getBCHAO());// B超其他异常标志
				hdPersonalHealthAssist.setCol0134(assistcheck.getBCHAO_EX());// B超其他异常描述
				hdPersonalHealthAssist.setCol0138(assistcheck.getFbBchao_EX());// 腹部B超检查异常描述
				hdPersonalHealthAssist.setCol0163(assistcheck.getALBUMIN());// 尿微量白蛋白（mg/dL)
				hdPersonalHealthAssist.setCol0164(assistcheck.getCERVIX_EX());// 宫颈涂片异常描述
				hdPersonalHealthAssist.setCol0198(assistcheck.getOTHER());// 辅助检查其他描述
				hdPersonalHealthAssist.setCol0199(assistcheck.getFPGDL());// 空腹血糖mg/dl
				hdPersonalHealthAssist.setRes0("2");

			}
			if (medicineResults.size() > 0) {
				OLD_MEDICINE_RESULT medicineResult = medicineResults.get(0);
			}

			if (assessmentguides.size() > 0) {
				// 健康评价与指导
				ARCHIVE_ASSESSMENTGUIDE assessmentguide = assessmentguides.get(0);
				hdPersonalHealth.setCol0142(assessmentguide.getHEALTHZHIDAO());// 健康指导代码
				hdPersonalHealth.setCol0188(assessmentguide.getEXCEPTION1());// 健康评价异常1描述
				hdPersonalHealth.setCol0189(assessmentguide.getAIM());// 目标体重（kg)
				hdPersonalHealth.setCol0190(assessmentguide.getADVICE());// 建议接种疫苗名称代码
				hdPersonalHealth.setCol0191(assessmentguide.getOTHER());// 危险因素控制其他
				hdPersonalHealth.setCol0140(assessmentguide.getISNORMAL());// 健康评价结果代码

				hdPersonalHealth.setRes2(assessmentguide.getDANGERCONTROL());
				hdPersonalHealth.setRes3(assessmentguide.getEXCEPTION2());
				hdPersonalHealth.setRes4(assessmentguide.getEXCEPTION3());
				hdPersonalHealth.setRes5(assessmentguide.getEXCEPTION4());

			}

			hdPersonalHealthAssist.setCreateorg(baseinfo.getCREATEORG());// 创建机构
			hdPersonalHealthAssist.setCreater(baseinfo.getCREATED_BY());// 创建人
			hdPersonalHealthAssist.setCreatetime(GlobalConts.datetimeFormat.format(new Date()));// 创建时间
			hdPersonalHealth.setCreateorg(baseinfo.getCREATEORG());// 创建机构
			hdPersonalHealth.setCreater(baseinfo.getCREATED_BY());// 创建人
			hdPersonalHealth.setCreatetime(GlobalConts.datetimeFormat.format(new Date()));// 创建时间
			healthCheck.setHdPersonalHealth(hdPersonalHealth);
			healthCheck.setHdPersonalHealthAssist(hdPersonalHealthAssist);

			String[] arr = GlobalConts.assessIntegrity(hdPersonalHealth.getCol0001(), hdPersonalHealth.getCol0010(),
					hdPersonalHealth.getCol0011(), hdPersonalHealth.getCol0013(), hdPersonalHealth.getCol0014(),
					hdPersonalHealth.getCol0015(), hdPersonalHealth.getCol0016(), hdPersonalHealth.getCol0019(),
					hdPersonalHealth.getCol0023(), hdPersonalHealth.getCol0024(), hdPersonalHealth.getCol0026(),
					hdPersonalHealth.getCol0027(), hdPersonalHealth.getCol0034(), hdPersonalHealth.getCol0036(),
					hdPersonalHealth.getCol0046(), hdPersonalHealth.getCol0052(), hdPersonalHealth.getCol0054(),
					hdPersonalHealth.getCol0055(), hdPersonalHealth.getCol0060(), hdPersonalHealth.getCol0068(),
					hdPersonalHealth.getCol0069(), hdPersonalHealth.getCol0070(), hdPersonalHealth.getCol0072(),
					hdPersonalHealth.getCol0073(), hdPersonalHealth.getCol0075(), hdPersonalHealth.getCol0076(),
					hdPersonalHealth.getCol0077(), hdPersonalHealth.getCol0140(), hdPersonalHealth.getCol0142(),
					hdPersonalHealth.getCol0146(), hdPersonalHealth.getCol0174(), hdPersonalHealth.getCol0176(),
					hdPersonalHealth.getCol0178(), hdPersonalHealth.getCol0180(), hdPersonalHealth.getCol0182(),
					hdPersonalHealth.getCol0184(), hdPersonalHealth.getCol0186(), hdPersonalHealth.getHappentime(),
					hdPersonalHealth.getHdPersonalAbstract().getDrink(),
					hdPersonalHealth.getHdPersonalAbstract().getFoodHabits(),
					hdPersonalHealth.getHdPersonalAbstract().getHazardsBio(),
					hdPersonalHealth.getHdPersonalAbstract().getSmoke(),
					hdPersonalHealth.getHdPersonalAbstract().getTrainingRate(), hdPersonalHealth.getSurgeonName());
			hdPersonalHealth.setWzd(arr[0]);// 完整度
			hdPersonalHealth.setQdqxz(arr[1]);// 缺项值
			healthCheckList.add(healthCheck);
		}
		return healthCheckList;

	}
}
